﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="GazOnDataSetall" targetNamespace="http://tempuri.org/GazOnDataSetall.xsd" xmlns:mstns="http://tempuri.org/GazOnDataSetall.xsd" xmlns="http://tempuri.org/GazOnDataSetall.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="GazOnConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GazOnConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.GazOnConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Accompanying_stocksTableAdapter" GeneratorDataComponentClassName="Accompanying_stocksTableAdapter" Name="Accompanying_stocks" UserDataComponentName="Accompanying_stocksTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GazOnConnectionString (Web.config)" DbObjectName="GazOn.dbo.Accompanying_stocks" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Accompanying_stocks] WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Accompanying_stocks] ([Title], [Count]) VALUES (@Title, @Count)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Title, Count FROM dbo.Accompanying_stocks</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Accompanying_stocks] SET [Title] = @Title, [Count] = @Count WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Count" DataSetColumn="Count" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomersTableAdapter" GeneratorDataComponentClassName="CustomersTableAdapter" Name="Customers" UserDataComponentName="CustomersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GazOnConnectionString (Web.config)" DbObjectName="GazOn.dbo.Customers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Customers] WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Customers] ([Name]) VALUES (@Name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Name FROM dbo.Customers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Customers] SET [Name] = @Name WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FixOperationsTableAdapter" GeneratorDataComponentClassName="FixOperationsTableAdapter" Name="FixOperations" UserDataComponentName="FixOperationsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GazOnConnectionString (Web.config)" DbObjectName="GazOn.dbo.FixOperations" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[FixOperations] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[FixOperations] ([Subject], [oreder]) VALUES (@Subject, @oreder)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@oreder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="oreder" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Subject, oreder FROM dbo.FixOperations</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[FixOperations] SET [Subject] = @Subject, [oreder] = @oreder WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@oreder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="oreder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Subject" DataSetColumn="Subject" />
              <Mapping SourceColumn="oreder" DataSetColumn="oreder" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="invoiceitemsTableAdapter" GeneratorDataComponentClassName="invoiceitemsTableAdapter" Name="invoiceitems" UserDataComponentName="invoiceitemsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GazOnConnectionString (Web.config)" DbObjectName="GazOn.dbo.invoiceitems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[invoiceitems] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[invoiceitems] ([title], [num], [amount], [note], [type], [typeid], [invoiceid]) VALUES (@title, @num, @amount, @note, @type, @typeid, @invoiceid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@num" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="num" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@amount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@typeid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoiceid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoiceid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, title, num, amount, note, type, typeid, invoiceid FROM dbo.invoiceitems</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[invoiceitems] SET [title] = @title, [num] = @num, [amount] = @amount, [note] = @note, [type] = @type, [typeid] = @typeid, [invoiceid] = @invoiceid WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@num" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="num" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@amount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@typeid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="typeid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoiceid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoiceid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="num" DataSetColumn="num" />
              <Mapping SourceColumn="amount" DataSetColumn="amount" />
              <Mapping SourceColumn="note" DataSetColumn="note" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="typeid" DataSetColumn="typeid" />
              <Mapping SourceColumn="invoiceid" DataSetColumn="invoiceid" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InvoicesTableAdapter" GeneratorDataComponentClassName="InvoicesTableAdapter" Name="Invoices" UserDataComponentName="InvoicesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GazOnConnectionString (Web.config)" DbObjectName="GazOn.dbo.Invoices" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Invoices] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Invoices] ([invoiceNumber], [_to], [date], [carnum], [address], [transporter], [invoiceItems]) VALUES (@invoiceNumber, @_to, @date, @carnum, @address, @transporter, @invoiceItems)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoiceNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoiceNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@_to" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@carnum" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="carnum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@transporter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="transporter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@invoiceItems" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="invoiceItems" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, invoiceNumber, [_to], date, carnum, address, transporter, invoiceItems FROM dbo.Invoices</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Invoices] SET [invoiceNumber] = @invoiceNumber, [_to] = @_to, [date] = @date, [carnum] = @carnum, [address] = @address, [transporter] = @transporter, [invoiceItems] = @invoiceItems WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoiceNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoiceNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@_to" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@carnum" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="carnum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@transporter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="transporter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@invoiceItems" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="invoiceItems" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="invoiceNumber" DataSetColumn="invoiceNumber" />
              <Mapping SourceColumn="_to" DataSetColumn="_to" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="carnum" DataSetColumn="carnum" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="transporter" DataSetColumn="transporter" />
              <Mapping SourceColumn="invoiceItems" DataSetColumn="invoiceItems" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Tank_StocksTableAdapter" GeneratorDataComponentClassName="Tank_StocksTableAdapter" Name="Tank_Stocks" UserDataComponentName="Tank_StocksTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GazOnConnectionString (Web.config)" DbObjectName="GazOn.dbo.Tank_Stocks" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Tank_Stocks] WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tank_Stocks] ([TankNumber], [TankSystemStatus], [type], [Datetime], [GazCompanyName], [GazCompanyAddress], [GazDistributor], [Year_of_manufacture], [Date_of_Fix], [manufacture_name], [Tank_Size], [Label_Number], [Address_Tank_From], [NumberOfZoklokPort], [tankStatus], [TankWithBase_baton], [PersonRecipetsignid], [TransportCompanyID], [orderName]) VALUES (@TankNumber, @TankSystemStatus, @type, @Datetime, @GazCompanyName, @GazCompanyAddress, @GazDistributor, @Year_of_manufacture, @Date_of_Fix, @manufacture_name, @Tank_Size, @Label_Number, @Address_Tank_From, @NumberOfZoklokPort, @tankStatus, @TankWithBase_baton, @PersonRecipetsignid, @TransportCompanyID, @orderName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TankNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TankNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TankSystemStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TankSystemStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Datetime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Datetime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GazCompanyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GazCompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GazCompanyAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GazCompanyAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GazDistributor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GazDistributor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Year_of_manufacture" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year_of_manufacture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date_of_Fix" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date_of_Fix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manufacture_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manufacture_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Tank_Size" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Tank_Size" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Label_Number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Label_Number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address_Tank_From" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_Tank_From" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfZoklokPort" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfZoklokPort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tankStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tankStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TankWithBase_baton" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TankWithBase_baton" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonRecipetsignid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonRecipetsignid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TransportCompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransportCompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@orderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="orderName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, TankNumber, TankSystemStatus, type, Datetime, GazCompanyName, GazCompanyAddress, GazDistributor, Year_of_manufacture, Date_of_Fix, manufacture_name, Tank_Size, Label_Number, Address_Tank_From, NumberOfZoklokPort, tankStatus, TankWithBase_baton, PersonRecipetsignid, TransportCompanyID, orderName FROM dbo.Tank_Stocks</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tank_Stocks] SET [TankNumber] = @TankNumber, [TankSystemStatus] = @TankSystemStatus, [type] = @type, [Datetime] = @Datetime, [GazCompanyName] = @GazCompanyName, [GazCompanyAddress] = @GazCompanyAddress, [GazDistributor] = @GazDistributor, [Year_of_manufacture] = @Year_of_manufacture, [Date_of_Fix] = @Date_of_Fix, [manufacture_name] = @manufacture_name, [Tank_Size] = @Tank_Size, [Label_Number] = @Label_Number, [Address_Tank_From] = @Address_Tank_From, [NumberOfZoklokPort] = @NumberOfZoklokPort, [tankStatus] = @tankStatus, [TankWithBase_baton] = @TankWithBase_baton, [PersonRecipetsignid] = @PersonRecipetsignid, [TransportCompanyID] = @TransportCompanyID, [orderName] = @orderName WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TankNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TankNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TankSystemStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TankSystemStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Datetime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Datetime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GazCompanyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GazCompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GazCompanyAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GazCompanyAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GazDistributor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GazDistributor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Year_of_manufacture" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year_of_manufacture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date_of_Fix" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date_of_Fix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manufacture_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manufacture_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Tank_Size" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Tank_Size" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Label_Number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Label_Number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address_Tank_From" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_Tank_From" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfZoklokPort" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfZoklokPort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tankStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tankStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TankWithBase_baton" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TankWithBase_baton" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonRecipetsignid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonRecipetsignid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TransportCompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransportCompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@orderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="orderName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="TankNumber" DataSetColumn="TankNumber" />
              <Mapping SourceColumn="TankSystemStatus" DataSetColumn="TankSystemStatus" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="Datetime" DataSetColumn="Datetime" />
              <Mapping SourceColumn="GazCompanyName" DataSetColumn="GazCompanyName" />
              <Mapping SourceColumn="GazCompanyAddress" DataSetColumn="GazCompanyAddress" />
              <Mapping SourceColumn="GazDistributor" DataSetColumn="GazDistributor" />
              <Mapping SourceColumn="Year_of_manufacture" DataSetColumn="Year_of_manufacture" />
              <Mapping SourceColumn="Date_of_Fix" DataSetColumn="Date_of_Fix" />
              <Mapping SourceColumn="manufacture_name" DataSetColumn="manufacture_name" />
              <Mapping SourceColumn="Tank_Size" DataSetColumn="Tank_Size" />
              <Mapping SourceColumn="Label_Number" DataSetColumn="Label_Number" />
              <Mapping SourceColumn="Address_Tank_From" DataSetColumn="Address_Tank_From" />
              <Mapping SourceColumn="NumberOfZoklokPort" DataSetColumn="NumberOfZoklokPort" />
              <Mapping SourceColumn="tankStatus" DataSetColumn="tankStatus" />
              <Mapping SourceColumn="TankWithBase_baton" DataSetColumn="TankWithBase_baton" />
              <Mapping SourceColumn="PersonRecipetsignid" DataSetColumn="PersonRecipetsignid" />
              <Mapping SourceColumn="TransportCompanyID" DataSetColumn="TransportCompanyID" />
              <Mapping SourceColumn="orderName" DataSetColumn="orderName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TankFixOperationTableAdapter" GeneratorDataComponentClassName="TankFixOperationTableAdapter" Name="TankFixOperation" UserDataComponentName="TankFixOperationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GazOnConnectionString (Web.config)" DbObjectName="GazOn.dbo.TankFixOperation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TankFixOperation] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TankFixOperation] ([tankID], [FixoperationID], [date], [amount], [note], [title]) VALUES (@tankID, @FixoperationID, @date, @amount, @note, @title)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FixoperationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixoperationID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@amount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, tankID, FixoperationID, date, amount, note, title FROM dbo.TankFixOperation</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TankFixOperation] SET [tankID] = @tankID, [FixoperationID] = @FixoperationID, [date] = @date, [amount] = @amount, [note] = @note, [title] = @title WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FixoperationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FixoperationID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@amount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="tankID" DataSetColumn="tankID" />
              <Mapping SourceColumn="FixoperationID" DataSetColumn="FixoperationID" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="amount" DataSetColumn="amount" />
              <Mapping SourceColumn="note" DataSetColumn="note" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="GazOnDataSetall" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="GazOnDataSetall" msprop:Generator_UserDSName="GazOnDataSetall">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Accompanying_stocks" msprop:Generator_TableClassName="Accompanying_stocksDataTable" msprop:Generator_TableVarName="tableAccompanying_stocks" msprop:Generator_TablePropName="Accompanying_stocks" msprop:Generator_RowDeletingName="Accompanying_stocksRowDeleting" msprop:Generator_UserTableName="Accompanying_stocks" msprop:Generator_RowChangingName="Accompanying_stocksRowChanging" msprop:Generator_RowEvHandlerName="Accompanying_stocksRowChangeEventHandler" msprop:Generator_RowDeletedName="Accompanying_stocksRowDeleted" msprop:Generator_RowEvArgName="Accompanying_stocksRowChangeEvent" msprop:Generator_RowChangedName="Accompanying_stocksRowChanged" msprop:Generator_RowClassName="Accompanying_stocksRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Count" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" msprop:Generator_UserColumnName="Count">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customers" msprop:Generator_TableClassName="CustomersDataTable" msprop:Generator_TableVarName="tableCustomers" msprop:Generator_TablePropName="Customers" msprop:Generator_RowDeletingName="CustomersRowDeleting" msprop:Generator_UserTableName="Customers" msprop:Generator_RowChangingName="CustomersRowChanging" msprop:Generator_RowEvHandlerName="CustomersRowChangeEventHandler" msprop:Generator_RowDeletedName="CustomersRowDeleted" msprop:Generator_RowEvArgName="CustomersRowChangeEvent" msprop:Generator_RowChangedName="CustomersRowChanged" msprop:Generator_RowClassName="CustomersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FixOperations" msprop:Generator_TableClassName="FixOperationsDataTable" msprop:Generator_TableVarName="tableFixOperations" msprop:Generator_TablePropName="FixOperations" msprop:Generator_RowDeletingName="FixOperationsRowDeleting" msprop:Generator_UserTableName="FixOperations" msprop:Generator_RowChangingName="FixOperationsRowChanging" msprop:Generator_RowEvHandlerName="FixOperationsRowChangeEventHandler" msprop:Generator_RowDeletedName="FixOperationsRowDeleted" msprop:Generator_RowEvArgName="FixOperationsRowChangeEvent" msprop:Generator_RowChangedName="FixOperationsRowChanged" msprop:Generator_RowClassName="FixOperationsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="Subject" msprop:Generator_ColumnVarNameInTable="columnSubject" msprop:Generator_ColumnPropNameInRow="Subject" msprop:Generator_ColumnPropNameInTable="SubjectColumn" msprop:Generator_UserColumnName="Subject" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="oreder" msprop:Generator_ColumnVarNameInTable="columnoreder" msprop:Generator_ColumnPropNameInRow="oreder" msprop:Generator_ColumnPropNameInTable="orederColumn" msprop:Generator_UserColumnName="oreder" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="invoiceitems" msprop:Generator_TableClassName="invoiceitemsDataTable" msprop:Generator_TableVarName="tableinvoiceitems" msprop:Generator_TablePropName="invoiceitems" msprop:Generator_RowDeletingName="invoiceitemsRowDeleting" msprop:Generator_UserTableName="invoiceitems" msprop:Generator_RowChangingName="invoiceitemsRowChanging" msprop:Generator_RowEvHandlerName="invoiceitemsRowChangeEventHandler" msprop:Generator_RowDeletedName="invoiceitemsRowDeleted" msprop:Generator_RowEvArgName="invoiceitemsRowChangeEvent" msprop:Generator_RowChangedName="invoiceitemsRowChanged" msprop:Generator_RowClassName="invoiceitemsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="num" msprop:Generator_ColumnVarNameInTable="columnnum" msprop:Generator_ColumnPropNameInRow="num" msprop:Generator_ColumnPropNameInTable="numColumn" msprop:Generator_UserColumnName="num" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="amount" msprop:Generator_ColumnVarNameInTable="columnamount" msprop:Generator_ColumnPropNameInRow="amount" msprop:Generator_ColumnPropNameInTable="amountColumn" msprop:Generator_UserColumnName="amount" type="xs:int" minOccurs="0" />
              <xs:element name="note" msprop:Generator_ColumnVarNameInTable="columnnote" msprop:Generator_ColumnPropNameInRow="note" msprop:Generator_ColumnPropNameInTable="noteColumn" msprop:Generator_UserColumnName="note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="typeid" msprop:Generator_ColumnVarNameInTable="columntypeid" msprop:Generator_ColumnPropNameInRow="typeid" msprop:Generator_ColumnPropNameInTable="typeidColumn" msprop:Generator_UserColumnName="typeid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="invoiceid" msprop:Generator_ColumnVarNameInTable="columninvoiceid" msprop:Generator_ColumnPropNameInRow="invoiceid" msprop:Generator_ColumnPropNameInTable="invoiceidColumn" msprop:Generator_UserColumnName="invoiceid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Invoices" msprop:Generator_TableClassName="InvoicesDataTable" msprop:Generator_TableVarName="tableInvoices" msprop:Generator_TablePropName="Invoices" msprop:Generator_RowDeletingName="InvoicesRowDeleting" msprop:Generator_UserTableName="Invoices" msprop:Generator_RowChangingName="InvoicesRowChanging" msprop:Generator_RowEvHandlerName="InvoicesRowChangeEventHandler" msprop:Generator_RowDeletedName="InvoicesRowDeleted" msprop:Generator_RowEvArgName="InvoicesRowChangeEvent" msprop:Generator_RowChangedName="InvoicesRowChanged" msprop:Generator_RowClassName="InvoicesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="invoiceNumber" msprop:Generator_ColumnVarNameInTable="columninvoiceNumber" msprop:Generator_ColumnPropNameInRow="invoiceNumber" msprop:Generator_ColumnPropNameInTable="invoiceNumberColumn" msprop:Generator_UserColumnName="invoiceNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="_to" msprop:Generator_ColumnVarNameInTable="column_to" msprop:Generator_ColumnPropNameInRow="_to" msprop:Generator_ColumnPropNameInTable="_toColumn" msprop:Generator_UserColumnName="_to" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="carnum" msprop:Generator_ColumnVarNameInTable="columncarnum" msprop:Generator_ColumnPropNameInRow="carnum" msprop:Generator_ColumnPropNameInTable="carnumColumn" msprop:Generator_UserColumnName="carnum" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnPropNameInTable="addressColumn" msprop:Generator_UserColumnName="address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="transporter" msprop:Generator_ColumnVarNameInTable="columntransporter" msprop:Generator_ColumnPropNameInRow="transporter" msprop:Generator_ColumnPropNameInTable="transporterColumn" msprop:Generator_UserColumnName="transporter" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="invoiceItems" msprop:Generator_ColumnVarNameInTable="columninvoiceItems" msprop:Generator_ColumnPropNameInRow="invoiceItems" msprop:Generator_ColumnPropNameInTable="invoiceItemsColumn" msprop:Generator_UserColumnName="invoiceItems" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tank_Stocks" msprop:Generator_TableClassName="Tank_StocksDataTable" msprop:Generator_TableVarName="tableTank_Stocks" msprop:Generator_TablePropName="Tank_Stocks" msprop:Generator_RowDeletingName="Tank_StocksRowDeleting" msprop:Generator_UserTableName="Tank_Stocks" msprop:Generator_RowChangingName="Tank_StocksRowChanging" msprop:Generator_RowEvHandlerName="Tank_StocksRowChangeEventHandler" msprop:Generator_RowDeletedName="Tank_StocksRowDeleted" msprop:Generator_RowEvArgName="Tank_StocksRowChangeEvent" msprop:Generator_RowChangedName="Tank_StocksRowChanged" msprop:Generator_RowClassName="Tank_StocksRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="TankNumber" msprop:Generator_ColumnVarNameInTable="columnTankNumber" msprop:Generator_ColumnPropNameInRow="TankNumber" msprop:Generator_ColumnPropNameInTable="TankNumberColumn" msprop:Generator_UserColumnName="TankNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TankSystemStatus" msprop:Generator_ColumnVarNameInTable="columnTankSystemStatus" msprop:Generator_ColumnPropNameInRow="TankSystemStatus" msprop:Generator_ColumnPropNameInTable="TankSystemStatusColumn" msprop:Generator_UserColumnName="TankSystemStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datetime" msprop:Generator_ColumnVarNameInTable="columnDatetime" msprop:Generator_ColumnPropNameInRow="Datetime" msprop:Generator_ColumnPropNameInTable="DatetimeColumn" msprop:Generator_UserColumnName="Datetime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="GazCompanyName" msprop:Generator_ColumnVarNameInTable="columnGazCompanyName" msprop:Generator_ColumnPropNameInRow="GazCompanyName" msprop:Generator_ColumnPropNameInTable="GazCompanyNameColumn" msprop:Generator_UserColumnName="GazCompanyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GazCompanyAddress" msprop:Generator_ColumnVarNameInTable="columnGazCompanyAddress" msprop:Generator_ColumnPropNameInRow="GazCompanyAddress" msprop:Generator_ColumnPropNameInTable="GazCompanyAddressColumn" msprop:Generator_UserColumnName="GazCompanyAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GazDistributor" msprop:Generator_ColumnVarNameInTable="columnGazDistributor" msprop:Generator_ColumnPropNameInRow="GazDistributor" msprop:Generator_ColumnPropNameInTable="GazDistributorColumn" msprop:Generator_UserColumnName="GazDistributor" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Year_of_manufacture" msprop:Generator_ColumnVarNameInTable="columnYear_of_manufacture" msprop:Generator_ColumnPropNameInRow="Year_of_manufacture" msprop:Generator_ColumnPropNameInTable="Year_of_manufactureColumn" msprop:Generator_UserColumnName="Year_of_manufacture" type="xs:int" minOccurs="0" />
              <xs:element name="Date_of_Fix" msprop:Generator_ColumnVarNameInTable="columnDate_of_Fix" msprop:Generator_ColumnPropNameInRow="Date_of_Fix" msprop:Generator_ColumnPropNameInTable="Date_of_FixColumn" msprop:Generator_UserColumnName="Date_of_Fix" type="xs:dateTime" minOccurs="0" />
              <xs:element name="manufacture_name" msprop:Generator_ColumnVarNameInTable="columnmanufacture_name" msprop:Generator_ColumnPropNameInRow="manufacture_name" msprop:Generator_ColumnPropNameInTable="manufacture_nameColumn" msprop:Generator_UserColumnName="manufacture_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tank_Size" msprop:Generator_ColumnVarNameInTable="columnTank_Size" msprop:Generator_ColumnPropNameInRow="Tank_Size" msprop:Generator_ColumnPropNameInTable="Tank_SizeColumn" msprop:Generator_UserColumnName="Tank_Size" type="xs:decimal" minOccurs="0" />
              <xs:element name="Label_Number" msprop:Generator_ColumnVarNameInTable="columnLabel_Number" msprop:Generator_ColumnPropNameInRow="Label_Number" msprop:Generator_ColumnPropNameInTable="Label_NumberColumn" msprop:Generator_UserColumnName="Label_Number" type="xs:int" minOccurs="0" />
              <xs:element name="Address_Tank_From" msprop:Generator_ColumnVarNameInTable="columnAddress_Tank_From" msprop:Generator_ColumnPropNameInRow="Address_Tank_From" msprop:Generator_ColumnPropNameInTable="Address_Tank_FromColumn" msprop:Generator_UserColumnName="Address_Tank_From" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumberOfZoklokPort" msprop:Generator_ColumnVarNameInTable="columnNumberOfZoklokPort" msprop:Generator_ColumnPropNameInRow="NumberOfZoklokPort" msprop:Generator_ColumnPropNameInTable="NumberOfZoklokPortColumn" msprop:Generator_UserColumnName="NumberOfZoklokPort" type="xs:int" minOccurs="0" />
              <xs:element name="tankStatus" msprop:Generator_ColumnVarNameInTable="columntankStatus" msprop:Generator_ColumnPropNameInRow="tankStatus" msprop:Generator_ColumnPropNameInTable="tankStatusColumn" msprop:Generator_UserColumnName="tankStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TankWithBase_baton" msprop:Generator_ColumnVarNameInTable="columnTankWithBase_baton" msprop:Generator_ColumnPropNameInRow="TankWithBase_baton" msprop:Generator_ColumnPropNameInTable="TankWithBase_batonColumn" msprop:Generator_UserColumnName="TankWithBase_baton" type="xs:boolean" minOccurs="0" />
              <xs:element name="PersonRecipetsignid" msprop:Generator_ColumnVarNameInTable="columnPersonRecipetsignid" msprop:Generator_ColumnPropNameInRow="PersonRecipetsignid" msprop:Generator_ColumnPropNameInTable="PersonRecipetsignidColumn" msprop:Generator_UserColumnName="PersonRecipetsignid" type="xs:int" minOccurs="0" />
              <xs:element name="TransportCompanyID" msprop:Generator_ColumnVarNameInTable="columnTransportCompanyID" msprop:Generator_ColumnPropNameInRow="TransportCompanyID" msprop:Generator_ColumnPropNameInTable="TransportCompanyIDColumn" msprop:Generator_UserColumnName="TransportCompanyID" type="xs:int" minOccurs="0" />
              <xs:element name="orderName" msprop:Generator_ColumnVarNameInTable="columnorderName" msprop:Generator_ColumnPropNameInRow="orderName" msprop:Generator_ColumnPropNameInTable="orderNameColumn" msprop:Generator_UserColumnName="orderName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TankFixOperation" msprop:Generator_TableClassName="TankFixOperationDataTable" msprop:Generator_TableVarName="tableTankFixOperation" msprop:Generator_TablePropName="TankFixOperation" msprop:Generator_RowDeletingName="TankFixOperationRowDeleting" msprop:Generator_UserTableName="TankFixOperation" msprop:Generator_RowChangingName="TankFixOperationRowChanging" msprop:Generator_RowEvHandlerName="TankFixOperationRowChangeEventHandler" msprop:Generator_RowDeletedName="TankFixOperationRowDeleted" msprop:Generator_RowEvArgName="TankFixOperationRowChangeEvent" msprop:Generator_RowChangedName="TankFixOperationRowChanged" msprop:Generator_RowClassName="TankFixOperationRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="tankID" msprop:Generator_ColumnVarNameInTable="columntankID" msprop:Generator_ColumnPropNameInRow="tankID" msprop:Generator_ColumnPropNameInTable="tankIDColumn" msprop:Generator_UserColumnName="tankID" type="xs:int" minOccurs="0" />
              <xs:element name="FixoperationID" msprop:Generator_ColumnVarNameInTable="columnFixoperationID" msprop:Generator_ColumnPropNameInRow="FixoperationID" msprop:Generator_ColumnPropNameInTable="FixoperationIDColumn" msprop:Generator_UserColumnName="FixoperationID" type="xs:int" minOccurs="0" />
              <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="amount" msprop:Generator_ColumnVarNameInTable="columnamount" msprop:Generator_ColumnPropNameInRow="amount" msprop:Generator_ColumnPropNameInTable="amountColumn" msprop:Generator_UserColumnName="amount" type="xs:int" minOccurs="0" />
              <xs:element name="note" msprop:Generator_ColumnVarNameInTable="columnnote" msprop:Generator_ColumnPropNameInRow="note" msprop:Generator_ColumnPropNameInTable="noteColumn" msprop:Generator_UserColumnName="note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Accompanying_stocks" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Customers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customers" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="FixOperations_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FixOperations" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="invoiceitems_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:invoiceitems" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Invoices_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Invoices" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Tank_Stocks_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tank_Stocks" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="TankFixOperation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TankFixOperation" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
</xs:schema>